﻿<%@ Page Language="C#"  EnableEventValidation = "false" AutoEventWireup="true" CodeBehind="SettleList_all.aspx.cs" Inherits="Customer_Profile.eCard.Settle.SettleList_all" %>
<%@ Register assembly="DevExpress.Web.ASPxGridView.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>
<%@ Register Src="~/mainTop.ascx" TagName="mainTop" TagPrefix="uc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">    
    <title>Customer List</title>
    <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR" />
    <meta content="C#" name="CODE_LANGUAGE" />
    <meta content="JavaScript" name="vs_defaultClientScript" />
    <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema" />
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <link href="/css/style.css" type="text/css" rel="stylesheet" />
    <script language="javascript" type="text/javascript" src="/js/common.js"></script>
    <script language="javascript" type="text/javascript" src="/js/CalPopUp.js"></script>
    <script language="javascript"  type="text/javascript">
        function checkForm() {
            var start_date = document.getElementById("txtcreatedatebegin").value;
            var end_date = document.getElementById("txtcreatedateend").value;

            if (trim(start_date) != '' && trim(end_date) != '') {
                if (!strDateTime(start_date)) {
                    alert('起始日期格式不准确');
                    return false;
                }
                if (!strDateTime(end_date)) {
                    alert('结束日期格式不准确');
                    return false;
                }
            }
            return true;
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <table height="100%" cellspacing="0" cellpadding="0" width="100%" border="0">
        <tr>
            <td width="1" background="/images/dot_vline.gif">
                <img height="1" src="/images/spacer.gif" width="1"></td>
            <td valign="top" width="15">
                <img height="1" src="/images/spacer.gif" width="15"></td>
            <td valign="top">
                <table cellspacing="0" cellpadding="0" width="100%" border="0">
                    <tr>
                        <td style="height: 23px">
                            <uc1:mainTop ID="MainTop1" runat="server" />
                            <span class="navi-blu"><span class="navi-blk">首页 &gt; 个人旅行卡管理 &gt; 结算查询</span>
                            </span>
                        </td>
                    </tr>
                    <tr>
                        <td background="/images/dot_hline.gif">
                            <img height="1" src="/images/spacer.gif" width="1"></td>
                    </tr>
                </table>
                <table style="position: relative; top: 6px" cellspacing="0" cellpadding="0" width="100%"
                    border="0">
                    <tr>
                        <td>
                            <img height="6" src="/images/corner_lft1.gif" width="6"></td>
                        <td>
                            <div align="right">
                                <img height="6" src="/images/corner_rgt1.gif" width="6"></div>
                        </td>
                    </tr>
                </table>
                <table cellspacing="1" cellpadding="4" width="100%" bgcolor="#c8c8c8" border="0">                        
                    <tr bgcolor="#e9e9e9">
                        <td>
                            <table cellspacing="0" cellpadding="0" width="100%" border="0">
                                <tr>
                                    <td width="100">
                                        <img height="9" hspace="5" src="/images/arw_gry_rgt.gif" width="9" align="absMiddle">地区：</td>
                                    <td>
                                         <asp:DropDownList ID="dropEntity" runat="server" Width="135">
                                            </asp:DropDownList>
                                    </td>
                                </tr>
                            </table>
                        </td>
                        <td>
                            <table cellspacing="0" cellpadding="0" width="100%" border="0">
                                <tr>
                                    <td width="100">
                                        <img height="9" hspace="5" src="/images/arw_gry_rgt.gif" width="9" align="absMiddle">状态：</td>
                                    <td>
                                        <asp:DropDownList ID="dropSettleStatus" runat="server">
                                        </asp:DropDownList>
                                    </td>
                                </tr>
                            </table>
                        </td>
                        <td>
                            <table cellspacing="0" cellpadding="0" width="100%" border="0">
                                <tr>
                                    <td>
                                        <img height="9" hspace="5" src="/images/arw_gry_rgt.gif" width="9" align="absMiddle">到期日期：</td>
                                    <td>
                                        From&nbsp;&nbsp;&nbsp;&nbsp;
                                        <asp:TextBox ID="txtcreatedatebegin" runat="server" CssClass="input2" Width="120px"></asp:TextBox>&nbsp;&nbsp;&nbsp;<img
                                            style="cursor: hand" onclick="JavaScript:calPopForCMon(txtcreatedatebegin, 'ss');"
                                            height="14" src="/images/dot_date.gif" width="16" align="absMiddle">
                                        &nbsp;&nbsp;&nbsp;&nbsp;To&nbsp;&nbsp;&nbsp;&nbsp;
                                        <asp:TextBox ID="txtcreatedateend" runat="server" CssClass="input2" Width="120px"></asp:TextBox>&nbsp;&nbsp;&nbsp;<img
                                            style="cursor: hand" onclick="JavaScript:calPopForCMon(txtcreatedateend, 'ss');"
                                            height="14" src="/images/dot_date.gif" width="16" align="absMiddle">
                                    </td>
                                </tr>
                            </table>
                        </td>
                        <td>
                            <div align="center">
                                <asp:Button ID="btnSearch" runat="server" Text="搜索" class="button" onclick="btnSearch_Click" onclientclick="return checkForm()"  />&nbsp;                                
                                <asp:Button ID="btnExport" runat="server" Text="导出" class="button" 
                                    onclick="btnExport_Click"/>&nbsp;                                
                            </div>
                        </td>
                    </tr>
                </table>
                <table style="position: relative; top: -6px" cellspacing="0" cellpadding="0" width="100%"
                    border="0">
                    <tr>
                        <td>
                            <img height="6" src="/images/corner_lft2.gif" width="6"></td>
                        <td>
                            <div align="right">
                                <img height="6" src="/images/corner_rgt2.gif" width="6"></div>
                        </td>
                    </tr>
                </table>
                <table bordercolor="#c2d2e2" cellspacing="0" cellpadding="2" width="100%" border="1">
                    <tr>
                        <td>
                            <table cellspacing="0" cellpadding="0" width="100%" border="0">
                                <tr>
                                    <td bgcolor="#1765a7">
                                        <img height="11" src="/images/pic_results.gif" width="61"></td>
                                </tr>
                            </table>                            
                            <table cellspacing="0" cellpadding="0" width="100%" border="0">
                                    <tr>
                                        <td class="bglist" width="5%">交易号</td>
                                        <td class="bglist"><img height="16" src="/images/dot_vline2.gif" width="1"></td>
                                        <td class="bglist" width="10%">卡号</td>
                                        <td class="bglist"><img height="16" src="/images/dot_vline2.gif" width="1"></td>
                                        <td class="bglist" width="10%">客户姓名</td>
                                        <td class="bglist"><img height="16" src="/images/dot_vline2.gif" width="1"></td>
                                        <td class="bglist" width="5%">地区</td>
                                        <td class="bglist"><img height="16" src="/images/dot_vline2.gif" width="1"></td>
                                        <td class="bglist" width="10%">产品名称</td>
                                        <td class="bglist"><img height="16" src="/images/dot_vline2.gif" width="1"></td>                                        
                                        <td class="bglist" width="10%">到期日</td>
                                        <td class="bglist"><img height="16" src="/images/dot_vline2.gif" width="1"></td>
                                        <td class="bglist" width="10%">结算状态</td>
                                        <td class="bglist"><img height="16" src="/images/dot_vline2.gif" width="1"></td>                                        
                                        <td class="bglist" width="8%">到期金额</td>
                                        <td class="bglist"><img height="16" src="/images/dot_vline2.gif" width="1"></td>
                                        <td class="bglist" width="8%">结算金额</td>
                                        <td class="bglist"><img height="16" src="/images/dot_vline2.gif" width="1"></td>
                                        <td class="bglist" width="8%">结算费率</td>
                                        <td class="bglist"><img height="16" src="/images/dot_vline2.gif" width="1"></td>
                                        <td class="bglist" width="8%">结算费用</td>
                                        <td class="bglist"><img height="16" src="/images/dot_vline2.gif" width="1"></td>
                                        <td class="bglist" width="8%">支付费用</td>                                        
                                    </tr>
                                    <tr>
                                        <td colspan="23">
                                            <font face="宋体"> 
                                                <div style="overflow: auto; width: 100%; height: 100%">
                                                    <asp:GridView ID="GvData" runat="server" ShowHeader="false" AutoGenerateColumns="False"
                                                        BorderWidth="0px" Width="100%" HorizontalAlign="Center"
                                                        Font-Size="Smaller" DataKeyNames="deal_no,settle_id,settle_status" AllowPaging="True" 
                                                        PageSize="20" onpageindexchanging="GvData_PageIndexChanging" 
                                                        onrowdatabound="GvData_RowDataBound">                                                        
                                                        <HeaderStyle HorizontalAlign="Center" BorderStyle="Groove" BackColor="#C0C0FF" />
                                                        <RowStyle HorizontalAlign="Center" CssClass="bglist-2" />
                                                        <Columns>                                                            
                                                            <asp:BoundField DataField="deal_no" HeaderText="卡号">
                                                                <ItemStyle Width="5%" />
                                                            </asp:BoundField>
                                                            <asp:TemplateField HeaderText="卡号" ItemStyle-Width="10%">
                                                                <ItemTemplate>
                                                                    <asp:LinkButton ID="LinkButton1" Text='<%#Eval("card_no") %>' runat="server"></asp:LinkButton>
                                                                </ItemTemplate>
                                                            </asp:TemplateField>
                                                            <asp:BoundField DataField="cparty_name" HeaderText="客户姓名">
                                                                <ItemStyle Width="10%" />
                                                            </asp:BoundField>
                                                            <asp:BoundField DataField="entity" HeaderText="地区">
                                                                <ItemStyle Width="5%" />
                                                            </asp:BoundField>
                                                            <asp:BoundField DataField="procduct_name" HeaderText="产品名称">
                                                                <ItemStyle Width="10%" />
                                                            </asp:BoundField>                                                                                                             
                                                            <asp:BoundField DataField="due_date" HeaderText="到期日" DataFormatString="{0:yyyy-MM-dd}">
                                                                <ItemStyle Width="10%" />
                                                            </asp:BoundField>
                                                            <asp:BoundField DataField="settle_status_name" HeaderText="结算状态">
                                                                <ItemStyle Width="10%" />
                                                            </asp:BoundField>                                                            
                                                            <asp:BoundField DataField="due_amount" HeaderText="到期金额">
                                                                <ItemStyle Width="8%" />
                                                            </asp:BoundField>
                                                            <asp:BoundField DataField="settle_amount" HeaderText="结算金额">
                                                                <ItemStyle Width="8%" />
                                                            </asp:BoundField>
                                                            <asp:BoundField DataField="settle_commission_percent" HeaderText="结算费率">
                                                                <ItemStyle Width="8%" />
                                                            </asp:BoundField>
                                                            <asp:BoundField DataField="settle_fee" HeaderText="结算费用">
                                                                <ItemStyle Width="8%" />
                                                            </asp:BoundField>
                                                            <asp:BoundField DataField="pay_amount" HeaderText="支付金额">
                                                                <ItemStyle Width="8%" />
                                                            </asp:BoundField>                                                             
                                                        </Columns>
                                                    </asp:GridView>
                                                </div>
                                            </font>
                                        </td>
                                    </tr>
                                </table>
                        </td>
                    </tr>
                </table>
                <table cellspacing="0" cellpadding="0" width="100%" border="0">
                    <tr>
                        <td>
                            <img height="3" src="/images/spacer.gif" width="1"></td>
                    </tr>
                </table>           
            </td>
            <td valign="top" width="10">
                <img height="1" alt="" src="/images/spacer.gif" width="10"></td>
        </tr>
    </table>
    </form>
</body>
</html>